UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0NTNpm+843yEbQxD2iS8H0/LjB7A1vjyh1S0pn1cqkc='
WHERE
key_id = '538a8a6b98e2fe33486b5b4078d67a1b4f4bb7f565fc3335d988f3c221add86f'
AND (
token = '0NTNpm+843yEbQxD2iS8H0/LjB7A1vjyh1S0pn1cqkc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)