UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cQkGMYajj5QeET0B/1ICST7H3qClbCMfgUNaiC108JQ='
WHERE
key_id = 'a39c6c4f297cd8cae59a2e15cf67a1059b564c3418dd6f3277a1b49c466f5dc8'
AND (
token = 'cQkGMYajj5QeET0B/1ICST7H3qClbCMfgUNaiC108JQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)