UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ChHW+NfjNhMPHV0btF/SAU3Rs95+1YGSt3+U79Ge7ZI='
WHERE
key_id = 'a917c4809ceab2b1095bc9d6d2ffd0aff8af5b5d2f9a252b15486d31d4874c6a'
AND (
token = 'ChHW+NfjNhMPHV0btF/SAU3Rs95+1YGSt3+U79Ge7ZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)