UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8BzAjQ6HByUWCnbTBdDudnIpnWLPeAd7WBIqWxanWTk='
WHERE
key_id = 'b8a6051e7d47bd0a345a54d216e3287696520dd7220b65067bd07c62417ac32c'
AND (
token = '8BzAjQ6HByUWCnbTBdDudnIpnWLPeAd7WBIqWxanWTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)