UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SNX0pAxnssNWg4R08TRKj1UsWlt0QjXPzFbz2xl5Hrs='
WHERE
key_id = '121c1b3d10e16c3966a27a45e9370664294cd2aa08cee05f33a4761ac3e7c2e4'
AND (
token = 'SNX0pAxnssNWg4R08TRKj1UsWlt0QjXPzFbz2xl5Hrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)