UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pgLc9f2cdRorQlTQjmmderHFxFz3ZJVKA31u7pVZ98o='
WHERE
key_id = '11f9ce90f20d7850cd8cb96add82ce8d82f55abdd635766f088d9b2d78e3005f'
AND (
token = 'pgLc9f2cdRorQlTQjmmderHFxFz3ZJVKA31u7pVZ98o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)