UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GD0DfWZ0qmmDkndV940Y49wfv6pv0dvcESEyZQ7pBCg='
WHERE
key_id = '3bd2b7479322478db9b23e1e7e7fac08c8ccababfa31529682b1295252bc37c4'
AND (
token = 'GD0DfWZ0qmmDkndV940Y49wfv6pv0dvcESEyZQ7pBCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)