UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XmRQ4C4PW4/TffTjrPox22UgF/67ib7vV77o5GBCSrA=' 
WHERE 
  key_id = 'a96fcb1466ec045d11532083e53f030340f4fd5fa33c08a9a8550a46d75de317' 
  AND (
    token = 'XmRQ4C4PW4/TffTjrPox22UgF/67ib7vV77o5GBCSrA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043