UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'h9KmyOqZfI7NgOLXHRcGbG3Le9+QqWKGySzo1vB4TQA=' 
WHERE 
  key_id = 'c2b5e133f87e54d00ab452645d05db258d38c0d640993dba5060eedb383cd7a2' 
  AND (
    token = 'h9KmyOqZfI7NgOLXHRcGbG3Le9+QqWKGySzo1vB4TQA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024