UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'cXEm8mC34mIzkcEklxk1CdeNI3lM2PzOeMwrNtQz7v8=' 
WHERE 
  key_id = 'bad4eb435a84de3ac6c94985e5c85622cc38e42e4fb72cc0119ea614e996b5ca' 
  AND (
    token = 'cXEm8mC34mIzkcEklxk1CdeNI3lM2PzOeMwrNtQz7v8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024