UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '46IPeb4fxM6wBg/LdhEcwkwlGBgIvv74U6E4DCWg2ZM='
WHERE
key_id = '3dabe99e1a44601fff727ab10f9a042123e758258e1d0219a06e658098452339'
AND (
token = '46IPeb4fxM6wBg/LdhEcwkwlGBgIvv74U6E4DCWg2ZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)