UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2CZa7al9B8qTaopMS1wWWeHK8PDrnP3ckBSVl8V/RWU='
WHERE
key_id = 'a2e79c91dc5d9a3e64b2bfe24d7f1a8fbf4edb40ffdc726d0c77cef7732c65e5'
AND (
token = '2CZa7al9B8qTaopMS1wWWeHK8PDrnP3ckBSVl8V/RWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)