UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4e4NCR1EcTMx3FYvkasqLe2De06yY0csr4U82EEK+3Q='
WHERE
key_id = 'a0f7472e033717acf5fb27e87516c5071503576e16ab6595f8f6a986ac0e1e17'
AND (
token = '4e4NCR1EcTMx3FYvkasqLe2De06yY0csr4U82EEK+3Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)