UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dkNxR2+2LtXik1Y2FCT54Zem84837t8HHcnBGh9eH30='
WHERE
key_id = '1d7fd7d9edf612f0bcac5a7718a3ab780e872d573bad02c7cb1a5c048636ed74'
AND (
token = 'dkNxR2+2LtXik1Y2FCT54Zem84837t8HHcnBGh9eH30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)