UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Pw7Aq1j1nF9xP8/KtxjNIsP1eXKjuL4J8piSCG1hUEk=' 
WHERE 
  key_id = '21e7e99b854d671322a161d2d3fcea39ebe9fdd12c3aa258a678129a32c15cd5' 
  AND (
    token = 'Pw7Aq1j1nF9xP8/KtxjNIsP1eXKjuL4J8piSCG1hUEk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030