UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gx9iQ31DIueYEfVTH+ABCYievpqm+IWbe9fv76aYEAU='
WHERE
key_id = 'c764a89ea48099d5850ab84b2e1de2b93fe69ab0970b39f64a79eba67df82017'
AND (
token = 'Gx9iQ31DIueYEfVTH+ABCYievpqm+IWbe9fv76aYEAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)