UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bAUlNMi2K7xYufCigmzsWJhNS0bzLYHgz+iXB/kjV9s='
WHERE
key_id = '4f0c80c533111d4b52c180b82c9c42a6f0417ecb54ad18c625e409332d4dc4e4'
AND (
token = 'bAUlNMi2K7xYufCigmzsWJhNS0bzLYHgz+iXB/kjV9s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)