UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nx5NGbHmwPYzQaqz4BDUGWV//KCRtetO4k57DoXTIaE='
WHERE
key_id = 'b5b8a99a8d6d8cb4411e45d29a1090161fcaa197600a318c2eb920ff113f9aef'
AND (
token = 'nx5NGbHmwPYzQaqz4BDUGWV//KCRtetO4k57DoXTIaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)