UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q9Yi2M7G64h4+wilHwwVuxLd42HcOEpdSvFx4HStWWw='
WHERE
key_id = '1d3aef13f2af41bb830cd6750495376a7371d90a3624e01fe38a70135ef632d3'
AND (
token = 'q9Yi2M7G64h4+wilHwwVuxLd42HcOEpdSvFx4HStWWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)