UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tcYL9QlF+cHSdavGG5yI1l1RvSUV+tuznP46/kqo2rs=' 
WHERE 
  key_id = 'd0b15847f2181231b3f5f249b0ef10faf92d6b212900f027a6c626dfa37ec9cb' 
  AND (
    token = 'tcYL9QlF+cHSdavGG5yI1l1RvSUV+tuznP46/kqo2rs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )