UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vCfLDhSKJuzv3PQ1v5b1Nr2MDNBv7o/7at3DUR2fWCk=' 
WHERE 
  key_id = '9842b2f593723b72134b1e603d2b206ada6ffb6634e79018ddac6c492542fada' 
  AND (
    token = 'vCfLDhSKJuzv3PQ1v5b1Nr2MDNBv7o/7at3DUR2fWCk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046