UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XM0HJZU2aR7qIAPOV5NfCpodEalY64f76oMRD5uSMtg='
WHERE
key_id = 'b6c25624604c03042cb90bf571bd1a8f650dc9ab53409112e5bdeb115b444a51'
AND (
token = 'XM0HJZU2aR7qIAPOV5NfCpodEalY64f76oMRD5uSMtg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)