UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dz2eg9ng6/kXnFu2x43R3P8ok5qkrdTDMfOLzpuvlFE='
WHERE
key_id = '5785d4b6738600ad583b562bcc4867cc8ff931441016d494895d38516bdd1b22'
AND (
token = 'Dz2eg9ng6/kXnFu2x43R3P8ok5qkrdTDMfOLzpuvlFE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)