UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5g9H/l8CA1dvQvwZVDpMI+PYKXcQMQ0hM9lOVfKEFN8=' 
WHERE 
  key_id = '4e040599a45f44fcdcb3e5260340ab912696a0caa87c4f5736bc85da2b0bd8f4' 
  AND (
    token = '5g9H/l8CA1dvQvwZVDpMI+PYKXcQMQ0hM9lOVfKEFN8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026