UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Er6P06RDHLU3nd2CG7P5egpLRN9PmRSvXN6/ZYOueuw=' 
WHERE 
  key_id = '043bc03a6afff20807a49073ebda7cfb18bb4b3bfc98138ed496908abb5e3a27' 
  AND (
    token = 'Er6P06RDHLU3nd2CG7P5egpLRN9PmRSvXN6/ZYOueuw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038