UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X//5G3pCkWuO6NjBimlj8XWqDZ7vSfsCY/9MB2XVKJY='
WHERE
key_id = '817e4c472df1b63fab2013b4c4b70f93cc2aac1df54a15396eb9a8ed93063802'
AND (
token = 'X//5G3pCkWuO6NjBimlj8XWqDZ7vSfsCY/9MB2XVKJY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)