UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nK6hVdYi0Xjk15/hKIWsP6pkIFVGwVlcw/WXUNetjfk='
WHERE
key_id = 'a113696981dca64ce8ec5ce413b977634ca0ca0f197d53440a076b8771d57c32'
AND (
token = 'nK6hVdYi0Xjk15/hKIWsP6pkIFVGwVlcw/WXUNetjfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)