UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QDQ36yN9MgVZ04ggzZapAu8pcsG7E3O4pnXo+OV5kGs=' 
WHERE 
  key_id = '59023901b64b9a463a7fc85928629e8b5e580cad5a73115076f2ed87b93c890e' 
  AND (
    token = 'QDQ36yN9MgVZ04ggzZapAu8pcsG7E3O4pnXo+OV5kGs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00052