UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+VigpW/Ng2lsYiYXcrpIzLL6PIJkWr4RGuz4AvIM6yE=' 
WHERE 
  key_id = 'fb94a6a1739c97f815b7875c50f76e874a9e2b285b0a40e65e7d8eb68fbcb3b2' 
  AND (
    token = '+VigpW/Ng2lsYiYXcrpIzLL6PIJkWr4RGuz4AvIM6yE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029