UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nSKYPZXdLuI89k1G1k5wu5EqsJlxa8HOCb4Mvy7Q1gU='
WHERE
key_id = '0f4c544afd00f3a3a5b9549de0fb0c61c0a16475a719e261d614fab9485fe324'
AND (
token = 'nSKYPZXdLuI89k1G1k5wu5EqsJlxa8HOCb4Mvy7Q1gU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)