UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CE9RlnL6eZWI23+PpY3lGTCYW4Stm9YfRCzLrq918yk=' 
WHERE 
  key_id = 'c012102429ae183e3110fba0b03626aa15f0e2069c6d41cdf6220ddd883481ff' 
  AND (
    token = 'CE9RlnL6eZWI23+PpY3lGTCYW4Stm9YfRCzLrq918yk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023