UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LTH0PmVYFYAb8VMgsAzC+uQryAEe78l9eWB9PmlXiRc='
WHERE
key_id = 'bb9b481e9d9eed99d6b1a211f6a938d8e1e38575b4353249fd421d7a5248a7b2'
AND (
token = 'LTH0PmVYFYAb8VMgsAzC+uQryAEe78l9eWB9PmlXiRc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)