UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sva/Km8Whf+2cS2ZkaJU3uNKiBNCrAEQXH1Uv1yWCdE='
WHERE
key_id = 'afca326b2c29972b7e6815425b2f1960e05316d5e95f859be0a608d3ebbb7bad'
AND (
token = 'Sva/Km8Whf+2cS2ZkaJU3uNKiBNCrAEQXH1Uv1yWCdE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)