UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E9ImNb1RNu8SSxpqEWAazbi4IBglGwYEY3SiXVR/FtA='
WHERE
key_id = '039787767d20da9e5b859e56637c14e26d5062bb9808588d444a6ec48fd0563d'
AND (
token = 'E9ImNb1RNu8SSxpqEWAazbi4IBglGwYEY3SiXVR/FtA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)