UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GivHqvBlTG/2fiUmN6PxqxdHX6Pf/90MdNEnSYU8koU='
WHERE
key_id = '3bb95b9cf2aa6a3f1e810778db9ffc30931aa2e2450a42fda0693c06c950f137'
AND (
token = 'GivHqvBlTG/2fiUmN6PxqxdHX6Pf/90MdNEnSYU8koU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)