UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5CbfoT8xQmo0EKmxwhRFJEj7EyviC59gwmONXVl7mB4=' 
WHERE 
  key_id = '9edc29f8c0dd1d2ad377d62e6fc8d3d13c5a1463ccc4877803dc28d7e49326ae' 
  AND (
    token = '5CbfoT8xQmo0EKmxwhRFJEj7EyviC59gwmONXVl7mB4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026