UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xAW7unVjRusFLYSN9JM9YHpIx48fr0HXOX72AXA2MBA=' 
WHERE 
  key_id = '9af2282a33fa6f1a2307e4b575b797dfc8e9fd90b6b7d017251f0769a645a25b' 
  AND (
    token = 'xAW7unVjRusFLYSN9JM9YHpIx48fr0HXOX72AXA2MBA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035