UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JKbaRj33+mRqmr1kCmCq07UMkT8/2bXckcpBCjJZdL4='
WHERE
key_id = '21d9e7bd0ed274893b87031b2a02a1b0b32611cef6a64433a633ebe9a8c2efef'
AND (
token = 'JKbaRj33+mRqmr1kCmCq07UMkT8/2bXckcpBCjJZdL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)