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