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

Query time 0.00054