UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JMHZi6gfi9QqnG0oJd3auSMjxLqc5/xVr/E7LLzIJOY=' 
WHERE 
  key_id = 'd6bac7a70a85bb20c0964ec4891db5f7ad210b88a5e3c58d553711246a5f1961' 
  AND (
    token = 'JMHZi6gfi9QqnG0oJd3auSMjxLqc5/xVr/E7LLzIJOY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037