UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oSa+7DkBo778u1m5m5E8BaN9kxG+ECG3wwBFz5oLd0A=' 
WHERE 
  key_id = 'd28faf5bf22a548fc4000a9d87aa6cc99d13645de51241585a07e8ae79183eeb' 
  AND (
    token = 'oSa+7DkBo778u1m5m5E8BaN9kxG+ECG3wwBFz5oLd0A=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034