UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QNaz9J1S/GYzP3SuQirjCpA5cMfMyREZI2sb4EPzJ28='
WHERE
key_id = 'a4c0d88652dd45f7858e408e378058cb5e713288d5151a55f49e6d457d35a7f7'
AND (
token = 'QNaz9J1S/GYzP3SuQirjCpA5cMfMyREZI2sb4EPzJ28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)