UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Rcn23tQSCfLQXJRh9Ev9KoUPjBfKdZbChPRdFbgHNNI=' 
WHERE 
  key_id = 'd1aed8afced6d43de6d5c81d9e09ed7d9b638b54739a6305dd47f711ca4d40e0' 
  AND (
    token = 'Rcn23tQSCfLQXJRh9Ev9KoUPjBfKdZbChPRdFbgHNNI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019