UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8dy+LFUKRqw6bp79ijM1YuIRvKc4lkbFjwmMwjuM9z8='
WHERE
key_id = 'cf7accf7cbd2d234457f61646ce0f3a8ccd74c650ce4981d1881e64c0ea0485a'
AND (
token = '8dy+LFUKRqw6bp79ijM1YuIRvKc4lkbFjwmMwjuM9z8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)