UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HtKl5wm2ixaRyj5K+3KJ0MkmNZkqbwZIbzYoJcAaYj0='
WHERE
key_id = '01f1ba057a7a63f92cc70f3413252db6a1c778dc85e4dd610deb0601923654e9'
AND (
token = 'HtKl5wm2ixaRyj5K+3KJ0MkmNZkqbwZIbzYoJcAaYj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)