UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/l6P4cy4i6xFYuBwgVMXxoZC9DtpBdo7p4Awkggi5EE=' 
WHERE 
  key_id = 'b186b6f3abeebcb64b98673ae114fd26d20190fc7a67b2a0653946a466d01ba0' 
  AND (
    token = '/l6P4cy4i6xFYuBwgVMXxoZC9DtpBdo7p4Awkggi5EE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023