UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'paa1+W6fut2PI6UvFaU7S+8j19z2ULos9dnXBPo3rxw='
WHERE
key_id = '1e59027b54480b5e272cf166af4928dd850ddd038d900b8d84d5a627a27d1697'
AND (
token = 'paa1+W6fut2PI6UvFaU7S+8j19z2ULos9dnXBPo3rxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)