UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G2Jc36EH77A5TSnXIjwj28ZjBVXP9Em5c/UPxayB4y0='
WHERE
key_id = 'b9ae272f697119b519221955f10d9f57e970b7547aa627acb7e816c462b7d847'
AND (
token = 'G2Jc36EH77A5TSnXIjwj28ZjBVXP9Em5c/UPxayB4y0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)