UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xQNGB2OMfnMwTwfSxozbw0cc8cbBe4ulGGr1EfhqRpc=' 
WHERE 
  key_id = '6151744f3c778bb28b62bf87e9f32dbbad5504a0261b8e205affe25b84c7975a' 
  AND (
    token = 'xQNGB2OMfnMwTwfSxozbw0cc8cbBe4ulGGr1EfhqRpc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00052