UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9JKYRrNd7sLilJT2dMujMoOVPHzdTO+RbYD7YORTjHw='
WHERE
key_id = 'cc96448685ae1adff684776950969d167c90cadd6037aeadf9f27faa7dc04dcc'
AND (
token = '9JKYRrNd7sLilJT2dMujMoOVPHzdTO+RbYD7YORTjHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)