UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2xcF/Rqe8BEG9pQnx9OWbH+t29fo8qUI8BhRBY+XXS0=' 
WHERE 
  key_id = '47339b45ccb321905d45cf407dc83b71d96c017f4ef3623c72c8f2193241d529' 
  AND (
    token = '2xcF/Rqe8BEG9pQnx9OWbH+t29fo8qUI8BhRBY+XXS0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022