UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vafA+7Lb2GKPY9bENi7thC3s3ia1TkEVgU6OY8uiD/w='
WHERE
key_id = 'b734985d4fdfeb934db5cd0851a48a52c4a5ba72cdfc57dd6fba6922bb41aeb3'
AND (
token = 'vafA+7Lb2GKPY9bENi7thC3s3ia1TkEVgU6OY8uiD/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)