UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zWGGIe8v++cS1ZSOsZWePA5Hsh7vMTm+LzI7HDTJkFU=' 
WHERE 
  key_id = '78943ff13c2098f20cb943d4b44b3ba844c342472f971f397a952aacf1b71c5d' 
  AND (
    token = 'zWGGIe8v++cS1ZSOsZWePA5Hsh7vMTm+LzI7HDTJkFU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032