UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pGE7ZWzvbJyb0o1cST8bVSJzuI0IM9CD+bZd/icVpL8='
WHERE
key_id = '0b7e35ab7d214528e3f74484a13bc0414a06e04ea6162fa3a32264df3e06e166'
AND (
token = 'pGE7ZWzvbJyb0o1cST8bVSJzuI0IM9CD+bZd/icVpL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)