UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MNgFGcJQ6b6IXFXu8hJy34RsUTRD1ZAnYp+U7IFFTFM='
WHERE
key_id = 'd455a758ac4076cd65b6430f9a916af9eed7d2cc9420347b4ac9a4a712146f2b'
AND (
token = 'MNgFGcJQ6b6IXFXu8hJy34RsUTRD1ZAnYp+U7IFFTFM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)