UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lApgyYltwEUdCBEulP/Vdp6GlL4g/OiEAzsGpR3Q4n4='
WHERE
key_id = '00b7b1ed338033eeb99372960159b51d210d2484f5b4c3ac47ce9ca63150dce2'
AND (
token = 'lApgyYltwEUdCBEulP/Vdp6GlL4g/OiEAzsGpR3Q4n4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)