UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XTc+qH6eM59vDbm5H56oclIubAAjz/0c3T0jM8agQFw=' 
WHERE 
  key_id = 'b0902f74063e298bf774cc55df3fd1653b64e31e159ea98302bc46abd0c3defa' 
  AND (
    token = 'XTc+qH6eM59vDbm5H56oclIubAAjz/0c3T0jM8agQFw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026