UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZT1k8tzEqgG2TP6EKfmGJ3gGzfiHKV3WETRfrl92YTQ=' 
WHERE 
  key_id = '407a6ebfa09ee99f347514da1730a84fc4581f918e34a6853d84bdd30561f6bb' 
  AND (
    token = 'ZT1k8tzEqgG2TP6EKfmGJ3gGzfiHKV3WETRfrl92YTQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024