UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ahd+afcjnQkGYBy/XCQMOh9XjrX6yYb6O6M6m0KU/c8=' 
WHERE 
  key_id = '7c5e696f816f2de8359b2c0a563db261b09ef923be7e026829a8b5a823bf4cd5' 
  AND (
    token = 'ahd+afcjnQkGYBy/XCQMOh9XjrX6yYb6O6M6m0KU/c8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020