UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '10s/jWSow+HpQ6UiUOqpxp9R86a4/2DIk1RgAEy567w=' 
WHERE 
  key_id = 'a4bd19d50e1c5f9764f3884cca3938b6ff5ff58b47621d465857eecc5e64122b' 
  AND (
    token = '10s/jWSow+HpQ6UiUOqpxp9R86a4/2DIk1RgAEy567w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033